{ "metadata": { "name": "" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "code", "collapsed": false, "input": [ "# The usual preamble\n", "%matplotlib inline\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "import numpy as np\n", "\n", "# Make the graphs a bit prettier, and bigger\n", "pd.set_option('display.mpl_style', 'default')\n", "plt.rcParams['figure.figsize'] = (15, 5)\n", "\n", "\n", "# This is necessary to show lots of columns in pandas 0.12. \n", "# Not necessary in pandas 0.13.\n", "pd.set_option('display.line_width', 5000) \n", "pd.set_option('display.max_columns', 60)" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 11 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Let's continue with our NYC 311 service requests example." ] }, { "cell_type": "code", "collapsed": false, "input": [ "complaints = pd.read_csv('../data/311-service-requests.csv')" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 12 }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 3.1 Selecting only noise complaints" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "I'd like to know which borough has the most noise complaints. First, we'll take a look at the data to see what it looks like:" ] }, { "cell_type": "code", "collapsed": false, "input": [ "complaints[:5]" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | Unique Key | \n", "Created Date | \n", "Closed Date | \n", "Agency | \n", "Agency Name | \n", "Complaint Type | \n", "Descriptor | \n", "Location Type | \n", "Incident Zip | \n", "Incident Address | \n", "Street Name | \n", "Cross Street 1 | \n", "Cross Street 2 | \n", "Intersection Street 1 | \n", "Intersection Street 2 | \n", "Address Type | \n", "City | \n", "Landmark | \n", "Facility Type | \n", "Status | \n", "Due Date | \n", "Resolution Action Updated Date | \n", "Community Board | \n", "Borough | \n", "X Coordinate (State Plane) | \n", "Y Coordinate (State Plane) | \n", "Park Facility Name | \n", "Park Borough | \n", "School Name | \n", "School Number | \n", "School Region | \n", "School Code | \n", "School Phone Number | \n", "School Address | \n", "School City | \n", "School State | \n", "School Zip | \n", "School Not Found | \n", "School or Citywide Complaint | \n", "Vehicle Type | \n", "Taxi Company Borough | \n", "Taxi Pick Up Location | \n", "Bridge Highway Name | \n", "Bridge Highway Direction | \n", "Road Ramp | \n", "Bridge Highway Segment | \n", "Garage Lot Name | \n", "Ferry Direction | \n", "Ferry Terminal Name | \n", "Latitude | \n", "Longitude | \n", "Location | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "26589651 | \n", "10/31/2013 02:08:41 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Talking | \n", "Street/Sidewalk | \n", "11432 | \n", "90-03 169 STREET | \n", "169 STREET | \n", "90 AVENUE | \n", "91 AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "JAMAICA | \n", "NaN | \n", "Precinct | \n", "Assigned | \n", "10/31/2013 10:08:41 AM | \n", "10/31/2013 02:35:17 AM | \n", "12 QUEENS | \n", "QUEENS | \n", "1042027 | \n", "197389 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.708275 | \n", "-73.791604 | \n", "(40.70827532593202, -73.79160395779721) | \n", "
1 | \n", "26593698 | \n", "10/31/2013 02:01:04 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Illegal Parking | \n", "Commercial Overnight Parking | \n", "Street/Sidewalk | \n", "11378 | \n", "58 AVENUE | \n", "58 AVENUE | \n", "58 PLACE | \n", "59 STREET | \n", "NaN | \n", "NaN | \n", "BLOCKFACE | \n", "MASPETH | \n", "NaN | \n", "Precinct | \n", "Open | \n", "10/31/2013 10:01:04 AM | \n", "NaN | \n", "05 QUEENS | \n", "QUEENS | \n", "1009349 | \n", "201984 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.721041 | \n", "-73.909453 | \n", "(40.721040535628305, -73.90945306791765) | \n", "
2 | \n", "26594139 | \n", "10/31/2013 02:00:24 AM | \n", "10/31/2013 02:40:32 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Music/Party | \n", "Club/Bar/Restaurant | \n", "10032 | \n", "4060 BROADWAY | \n", "BROADWAY | \n", "WEST 171 STREET | \n", "WEST 172 STREET | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 10:00:24 AM | \n", "10/31/2013 02:39:42 AM | \n", "12 MANHATTAN | \n", "MANHATTAN | \n", "1001088 | \n", "246531 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.843330 | \n", "-73.939144 | \n", "(40.84332975466513, -73.93914371913482) | \n", "
3 | \n", "26595721 | \n", "10/31/2013 01:56:23 AM | \n", "10/31/2013 02:21:48 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Vehicle | \n", "Car/Truck Horn | \n", "Street/Sidewalk | \n", "10023 | \n", "WEST 72 STREET | \n", "WEST 72 STREET | \n", "COLUMBUS AVENUE | \n", "AMSTERDAM AVENUE | \n", "NaN | \n", "NaN | \n", "BLOCKFACE | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 09:56:23 AM | \n", "10/31/2013 02:21:10 AM | \n", "07 MANHATTAN | \n", "MANHATTAN | \n", "989730 | \n", "222727 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.778009 | \n", "-73.980213 | \n", "(40.7780087446372, -73.98021349023975) | \n", "
4 | \n", "26590930 | \n", "10/31/2013 01:53:44 AM | \n", "NaN | \n", "DOHMH | \n", "Department of Health and Mental Hygiene | \n", "Rodent | \n", "Condition Attracting Rodents | \n", "Vacant Lot | \n", "10027 | \n", "WEST 124 STREET | \n", "WEST 124 STREET | \n", "LENOX AVENUE | \n", "ADAM CLAYTON POWELL JR BOULEVARD | \n", "NaN | \n", "NaN | \n", "BLOCKFACE | \n", "NEW YORK | \n", "NaN | \n", "NaN | \n", "Pending | \n", "11/30/2013 01:53:44 AM | \n", "10/31/2013 01:59:54 AM | \n", "10 MANHATTAN | \n", "MANHATTAN | \n", "998815 | \n", "233545 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.807691 | \n", "-73.947387 | \n", "(40.80769092704951, -73.94738703491433) | \n", "
5 rows \u00d7 52 columns
\n", "\n", " | Unique Key | \n", "Created Date | \n", "Closed Date | \n", "Agency | \n", "Agency Name | \n", "Complaint Type | \n", "Descriptor | \n", "Location Type | \n", "Incident Zip | \n", "Incident Address | \n", "Street Name | \n", "Cross Street 1 | \n", "Cross Street 2 | \n", "Intersection Street 1 | \n", "Intersection Street 2 | \n", "Address Type | \n", "City | \n", "Landmark | \n", "Facility Type | \n", "Status | \n", "Due Date | \n", "Resolution Action Updated Date | \n", "Community Board | \n", "Borough | \n", "X Coordinate (State Plane) | \n", "Y Coordinate (State Plane) | \n", "Park Facility Name | \n", "Park Borough | \n", "School Name | \n", "School Number | \n", "School Region | \n", "School Code | \n", "School Phone Number | \n", "School Address | \n", "School City | \n", "School State | \n", "School Zip | \n", "School Not Found | \n", "School or Citywide Complaint | \n", "Vehicle Type | \n", "Taxi Company Borough | \n", "Taxi Pick Up Location | \n", "Bridge Highway Name | \n", "Bridge Highway Direction | \n", "Road Ramp | \n", "Bridge Highway Segment | \n", "Garage Lot Name | \n", "Ferry Direction | \n", "Ferry Terminal Name | \n", "Latitude | \n", "Longitude | \n", "Location | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "26589651 | \n", "10/31/2013 02:08:41 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Talking | \n", "Street/Sidewalk | \n", "11432 | \n", "90-03 169 STREET | \n", "169 STREET | \n", "90 AVENUE | \n", "91 AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "JAMAICA | \n", "NaN | \n", "Precinct | \n", "Assigned | \n", "10/31/2013 10:08:41 AM | \n", "10/31/2013 02:35:17 AM | \n", "12 QUEENS | \n", "QUEENS | \n", "1042027 | \n", "197389 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.708275 | \n", "-73.791604 | \n", "(40.70827532593202, -73.79160395779721) | \n", "
16 | \n", "26594086 | \n", "10/31/2013 12:54:03 AM | \n", "10/31/2013 02:16:39 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Music/Party | \n", "Street/Sidewalk | \n", "10310 | \n", "173 CAMPBELL AVENUE | \n", "CAMPBELL AVENUE | \n", "HENDERSON AVENUE | \n", "WINEGAR LANE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "STATEN ISLAND | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 08:54:03 AM | \n", "10/31/2013 02:07:14 AM | \n", "01 STATEN ISLAND | \n", "STATEN ISLAND | \n", "952013 | \n", "171076 | \n", "Unspecified | \n", "STATEN ISLAND | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.636182 | \n", "-74.116150 | \n", "(40.63618202176914, -74.1161500428337) | \n", "
25 | \n", "26591573 | \n", "10/31/2013 12:35:18 AM | \n", "10/31/2013 02:41:35 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Talking | \n", "Street/Sidewalk | \n", "10312 | \n", "24 PRINCETON LANE | \n", "PRINCETON LANE | \n", "HAMPTON GREEN | \n", "DEAD END | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "STATEN ISLAND | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 08:35:18 AM | \n", "10/31/2013 01:45:17 AM | \n", "03 STATEN ISLAND | \n", "STATEN ISLAND | \n", "929577 | \n", "140964 | \n", "Unspecified | \n", "STATEN ISLAND | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.553421 | \n", "-74.196743 | \n", "(40.55342078716953, -74.19674315017886) | \n", "
3 rows \u00d7 52 columns
\n", "\n", " | Unique Key | \n", "Created Date | \n", "Closed Date | \n", "Agency | \n", "Agency Name | \n", "Complaint Type | \n", "Descriptor | \n", "Location Type | \n", "Incident Zip | \n", "Incident Address | \n", "Street Name | \n", "Cross Street 1 | \n", "Cross Street 2 | \n", "Intersection Street 1 | \n", "Intersection Street 2 | \n", "Address Type | \n", "City | \n", "Landmark | \n", "Facility Type | \n", "Status | \n", "Due Date | \n", "Resolution Action Updated Date | \n", "Community Board | \n", "Borough | \n", "X Coordinate (State Plane) | \n", "Y Coordinate (State Plane) | \n", "Park Facility Name | \n", "Park Borough | \n", "School Name | \n", "School Number | \n", "School Region | \n", "School Code | \n", "School Phone Number | \n", "School Address | \n", "School City | \n", "School State | \n", "School Zip | \n", "School Not Found | \n", "School or Citywide Complaint | \n", "Vehicle Type | \n", "Taxi Company Borough | \n", "Taxi Pick Up Location | \n", "Bridge Highway Name | \n", "Bridge Highway Direction | \n", "Road Ramp | \n", "Bridge Highway Segment | \n", "Garage Lot Name | \n", "Ferry Direction | \n", "Ferry Terminal Name | \n", "Latitude | \n", "Longitude | \n", "Location | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31 | \n", "26595564 | \n", "10/31/2013 12:30:36 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Music/Party | \n", "Street/Sidewalk | \n", "11236 | \n", "AVENUE J | \n", "AVENUE J | \n", "EAST 80 STREET | \n", "EAST 81 STREET | \n", "NaN | \n", "NaN | \n", "BLOCKFACE | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Open | \n", "10/31/2013 08:30:36 AM | \n", "NaN | \n", "18 BROOKLYN | \n", "BROOKLYN | \n", "1008937 | \n", "170310 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.634104 | \n", "-73.911055 | \n", "(40.634103775951736, -73.91105541883589) | \n", "
49 | \n", "26595553 | \n", "10/31/2013 12:05:10 AM | \n", "10/31/2013 02:43:43 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Talking | \n", "Street/Sidewalk | \n", "11225 | \n", "25 LEFFERTS AVENUE | \n", "LEFFERTS AVENUE | \n", "WASHINGTON AVENUE | \n", "BEDFORD AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 08:05:10 AM | \n", "10/31/2013 01:29:29 AM | \n", "09 BROOKLYN | \n", "BROOKLYN | \n", "995366 | \n", "180388 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.661793 | \n", "-73.959934 | \n", "(40.6617931276793, -73.95993363978067) | \n", "
109 | \n", "26594653 | \n", "10/30/2013 11:26:32 PM | \n", "10/31/2013 12:18:54 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Music/Party | \n", "Street/Sidewalk | \n", "11222 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "DOBBIN STREET | \n", "NORMAN STREET | \n", "INTERSECTION | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 07:26:32 AM | \n", "10/31/2013 12:18:54 AM | \n", "01 BROOKLYN | \n", "BROOKLYN | \n", "996925 | \n", "203271 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.724600 | \n", "-73.954271 | \n", "(40.724599563793525, -73.95427134534344) | \n", "
236 | \n", "26591992 | \n", "10/30/2013 10:02:58 PM | \n", "10/30/2013 10:23:20 PM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Talking | \n", "Street/Sidewalk | \n", "11218 | \n", "DITMAS AVENUE | \n", "DITMAS AVENUE | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "LATLONG | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 06:02:58 AM | \n", "10/30/2013 10:23:20 PM | \n", "01 BROOKLYN | \n", "BROOKLYN | \n", "991895 | \n", "171051 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.636169 | \n", "-73.972455 | \n", "(40.63616876563881, -73.97245504682485) | \n", "
370 | \n", "26594167 | \n", "10/30/2013 08:38:25 PM | \n", "10/30/2013 10:26:28 PM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Music/Party | \n", "Street/Sidewalk | \n", "11218 | \n", "126 BEVERLY ROAD | \n", "BEVERLY ROAD | \n", "CHURCH AVENUE | \n", "EAST 2 STREET | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 04:38:25 AM | \n", "10/30/2013 10:26:28 PM | \n", "12 BROOKLYN | \n", "BROOKLYN | \n", "990144 | \n", "173511 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.642922 | \n", "-73.978762 | \n", "(40.6429222774404, -73.97876175474585) | \n", "
5 rows \u00d7 52 columns
\n", "\n", " | Complaint Type | \n", "Borough | \n", "Created Date | \n", "Descriptor | \n", "
---|---|---|---|---|
31 | \n", "Noise - Street/Sidewalk | \n", "BROOKLYN | \n", "10/31/2013 12:30:36 AM | \n", "Loud Music/Party | \n", "
49 | \n", "Noise - Street/Sidewalk | \n", "BROOKLYN | \n", "10/31/2013 12:05:10 AM | \n", "Loud Talking | \n", "
109 | \n", "Noise - Street/Sidewalk | \n", "BROOKLYN | \n", "10/30/2013 11:26:32 PM | \n", "Loud Music/Party | \n", "
236 | \n", "Noise - Street/Sidewalk | \n", "BROOKLYN | \n", "10/30/2013 10:02:58 PM | \n", "Loud Talking | \n", "
370 | \n", "Noise - Street/Sidewalk | \n", "BROOKLYN | \n", "10/30/2013 08:38:25 PM | \n", "Loud Music/Party | \n", "
378 | \n", "Noise - Street/Sidewalk | \n", "BROOKLYN | \n", "10/30/2013 08:32:13 PM | \n", "Loud Talking | \n", "
656 | \n", "Noise - Street/Sidewalk | \n", "BROOKLYN | \n", "10/30/2013 06:07:39 PM | \n", "Loud Music/Party | \n", "
1251 | \n", "Noise - Street/Sidewalk | \n", "BROOKLYN | \n", "10/30/2013 03:04:51 PM | \n", "Loud Talking | \n", "
5416 | \n", "Noise - Street/Sidewalk | \n", "BROOKLYN | \n", "10/29/2013 10:07:02 PM | \n", "Loud Talking | \n", "
5584 | \n", "Noise - Street/Sidewalk | \n", "BROOKLYN | \n", "10/29/2013 08:15:59 PM | \n", "Loud Music/Party | \n", "
10 rows \u00d7 4 columns
\n", "